Custom programming using Active Server Pages (ASP), Cold Fusion, Java Servlets, Java Server Pages (JSP), Access. Database design and programming T-SQL store procs, SQL - SQL Server 6.5/7.0
Provides ANSI-SQL solutions to common database query/update tasks. These apply to such relational databases as PostGreSQL, MySQL, Microsoft SQL Server, Oracle, Microsoft Access, SQLite.
This article provides a brief SQL How-to on how to summarize data. Most of the examples we provide will be based on the ANSI-SQL 92 standard. Some examples will show features specific to SQL Server 7.